MacWorld 1996 July/Macworld (1996-07).dmg/System 7.5 Update 2.0/FileMaker Pro 3.0 CD Extras/FileMaker Templates/Business/Purchase Orders

FileMaker Pro Database | 1996-01-25 | 113KB | 687 lines

Consult
ClarisII
CLARISII
Personnel Records.fp3
PERSON~1.FP3
HARDDISK
\\PAULFARRAH\C
CONSULT\ClarisII\v3\Personnel Records.fp3
..\..\CONSULT\ClarisII\v3\Personnel Records.fp3
C:\CONSULT\ClarisII\v3
a[',>
HBAM2016AUG95
Pro 3.0
000000000000001313131313131313
1307000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000071313131313131313
131313070000000
000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000007131300030B03001313
1313131313130700000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000
HBAM3016AUG95
HP DeskJet 540 Printer
Pro 2.0 - 2.1F!
Pro 3.0
BILL TO CITY
BILL TO COMPANY
BILL TO ID
BILL TO NAME
BILL TO STATE
BILL TO STREET
BILL TO ZIP CODE
CREATED BY
DATE CREATED
DATE MODIFIED
DISCOUNT
DISCOUNT RATE
F.O.B.
ORDER TOTAL
PRODUCT DESCRIPTION
PRODUCT EXTENDED AMOUNT
PRODUCT ID
PRODUCT QUANTITY
PRODUCT UNIT PRICE
PURCHASE ORDER ID
REQUESTED BY
5    SALES TAX
SALES TAX RATE
-    SHIP DATE
SHIP TO CITY
SHIP TO COMPANY
SHIP TO ID
SHIP TO NAME
SHIP TO STATE
SHIP TO STREET
SHIP TO ZIP CODE
SHIP VIA
SHIPPING
SUBTOTAL
SUPPLIER CITY
SUPPLIER COMPANY
SUPPLIER ID
SUPPLIER STATE
SUPPLIER STREET
SUPPLIER ZIP CODE
TERMS
WEIGHT
    USENG.NDX
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
11/20/95
A    Form View
A    List View
Purchase Order Report
Information
Report Menu
A    Form ViewB
Purchase Order IDB
o NameB
DateB
Bill To StreetB
Bill To StateB
Bill To ZIP CodeB
Date CreatedB
Date ModifiedB
Ship To NameB
Bill To CityB
Bill To CompanyB
Ship To CompanyB
Ship To StreetB
Ship To CityB
Ship To StateB
Ship To ZIP CodeB
Product IDB
Product DescriptionB
Product QuantityB
Product Unit PriceB
Product Extended AmountB
) ) *
SubtotalB
Sales Tax RateB
.A    Sales TaxB
4) *
ShippingB
Order TotalB
Discount RateB
DiscountB
Requested ByB
7A    Ship DateB
TermsB
Net 30
F.O.B.B
Ship ViaB
Ground
WeightB
Created ByB
Supplier CompanyB
Supplier StreetB
Supplier CityB
Supplier State
Supplier ZIP CodeB
Supplier IDB
Bill To IDB
Ship To IDB
InfoB
Description
Use this database file to track purchase orders.  FileMaker Pro automatically calculates sales tax and product discounts.
How to use this solution
You can update the sales tax and discount rate by updating the values in those fields. The Purchase Order report prints a typical purchase order form.
How to customize this solution
You can create lookups in this file to your own product database file or even your suppliers' files. A lookup based on Product ID can find information B
for Description and Price. A lookup based on Supplier Company can enter information such as the supplier's address and discount rate.
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
A    List ViewB
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Total
Shipping
Discount
Subtotal
Requested By
Weight
Ship Via
    Ship Date
F.O.B.
Terms
Extended Amount
Price
Description
Prod. ID
Supplier
P.O. No.
Ship To
Bill To
Enter data for Purchase Orders
Purchase Order ReportB
TotalW
Requested ByX
SupplierY
DateZ
Order ID[
Your Own
Button\
Your Own
Button]
Record^
Delete
Record_
Record`
Reportsa
View As
Listb
View As
Formc
Closed
Infoe2Click to see more information for a Purchase Order
InformationB
Your Own
Button
Reports
View As
View As
Close
Extended Amount
Price
Quantity
Description
Product ID
Weight:
Total:
h    Shipping:
j    Discount:
k    Subtotal:
Ship Via
m    Ship Date
F.O.B.
Terms
Requested By
Ship To
Bill To
Supplier
P.O. No.
Purchase Order
Company Name and Logo
ABCE>>, <<
ABCF>> <<
ABCG>>
ABCA>>, <<
ABAI>> <<
ABAK>>
ABDP>>, <<
ABEA>> <<
ABEB>>
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO.Information about the Purchase Orders solutionP
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Purchase Order ReportE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Sort by Supplier
Sort by Requested By
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Open Script
)=400
ecision )
Upper ( text )
CancelYear ( date ))
WeekofYearFi
cal ( date , starting
day )
WordYou did not enter any find criteria; all records will be displayed.C,
) = 0
ecision )
Upper ( text )
CancelYear ( date ))
WeekofYearFi
cal ( date , starting
day )
WordNo records match this request.E,
) = 1
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Sort by Date
Sort by Supplier
Sort by Requested By
Purchase Order Report
Open Script
Sort by Date
Purchase Order Report
Sort by Supplier
Sort by Requested By
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA
Ground
VDEFA(
Ship Via List
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
(*)(%,3&
)%+@6)
",30,)%
UUUUUU
wwwwww
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Bill To NameB
DateB
Bill To StreetB
Bill To StateB
Bill To ZIP CodeB
Date CreatedB
Date ModifiedB
Ship To NameB
Bill To CityB
Bill To CompanyB
Ship To CompanyB
Ship To StreetB
Ship To CityB
Ship To StateB
Ship To ZIP CodeB
Product IDB
Product DescriptionB
Product QuantityB
Product Unit PriceB